Release 10.1A: OpenEdge Development:
Internationalizing Applications

Characteristics of OpenEdge SQL clients

OpenEdge SQL clients have:

An internal code page.
A code page for displaying PROMSGS sent by the server to the client.

Internal code page

For Java/JDBC clients, the internal code page is Unicode, which is converted to UTF-8, an encoding of Unicode, to communicate with the JDBC driver. For more information on Unicode and UTF-8, see Chapter 9, " Using Unicode."

For ODBC clients, the internal code page is the value of the client’s SQL_CLIENT_CHARSET environment variable, if set; otherwise, the internal code page is that of the client’s default locale. For more information on the SQL_CLIENT_CHARSET environment variable, see OpenEdge Getting Started: Installation and Configuration .

Code page for displaying PROMSGS sent by the server to the client

When PROMSGS messages sent by the database server arrive at the client, the client accesses them using a particular code page:

The code page named by the client’s SQL_CLIENT_CHARSET_PROMSGS environment variable, if it is set.
Otherwise, the code page named by the client’s SQL_CLIENT_CHARSET environment variable, if it is set.
Otherwise, the code page of the client’s default locale.